MySQL Cli 使用

检查用户是否存在

mysql -e "SELECT EXISTS(SELECT 1 FROM mysql.user WHERE user = 'root');" -u root  -p123456 -N -s 2>/dev/null

• 这里的 2>/dev/null 是为了将错误输出丢弃
• -N 表示 –skip-column-names
• -s 则是只显示内容

mysql -e "GRANT SELECT ON *.* TO 'test3'@localhost IDENTIFIED BY 'test3';" -u root  -p123456 -N -s 2>/dev/null

if [ $(mysql -e "SELECT EXISTS(SELECT 1 FROM mysql.user WHERE user = '$(echo 'root')');" -u root  -p123456 -N -s 2>/dev/null) = 1 ]; then echo 'hello'; else echo 'world'; fi

更新账号密码

GRANT USAGE ON *.* TO 'user'@'hostname' IDENTIFIED BY 'newpwd';
GRANT USAGE ON *.* TO '$(middlewomen config -g 'storage.mysql.username')'@'localhost' IDENTIFIED BY '$(middlewomen config -g 'storage.mysql.password')'

set password for $(middlewomen config -g 'storage.mysql.username')@localhost=password('$(middlewomen config -g 'storage.mysql.password')');